package cn.kpi.dao.pingyou;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import cn.kpi.common.persistence.MyBatisDao;
import cn.kpi.entity.usualassessment.UserUATMzpdSummaryEntity;

@MyBatisDao
public interface PyResultDao {
 public int UpdateMzpdSummaryStatusById(@Param("mzpdsummaryid")Long mzpdsummaryid,@Param("status")int status)throws Exception;
 public List<UserUATMzpdSummaryEntity> GetMzpdSummaryListByWhere(@Param("where")String where,@Param("year")int year,@Param("username") String username)throws Exception;
 public int GetMzpdSummaryListCountByWhere(@Param("where")String where,@Param("year")int year,@Param("username") String username)throws Exception;
 
 public List<Map> GetOrgPyResultTjList(@Param("where")String where,@Param("year")int year,@Param("quarter")int quarter)throws Exception;
 public List<Map> GetOrgPyResultTjStatus(@Param("year")int year,@Param("quarter")int quarter)throws Exception;

 public int insertUserorghz(@Param("year")int year,@Param("quarter")int quarter)throws Exception;
 public int deleteUserorghz(@Param("year")int year,@Param("quarter")int quarter)throws Exception;

 public List<Map> GetOldOrgPyResultTjList(@Param("where")String where,@Param("year")int year,@Param("quarter")int quarter)throws Exception;
 
 public int UpdateOrgStatusGd(@Param("byuserid")Long byuserid,@Param("orgstatustjid")Long orgstatustjid,@Param("remark") String remark)throws Exception;
 public int UpdateOrgStatusBh(@Param("byuserid")Long byuserid,@Param("orgstatustjid")Long orgstatustjid,@Param("remark") String remark)throws Exception;
 public int UpdateUserNodeMzpdForBh(@Param("orgid")Long orgid,@Param("year")int year,@Param("quarter")int quarter)throws Exception;
 public int UpdateMzpdStatusForBh(@Param("orgid")Long orgid,@Param("year")int year,@Param("quarter")int quarter)throws Exception;
}
